﻿using System;

namespace edowork.com.Model
{
    #region purchaseplanInfo

    [Serializable]
    public class purchaseplanInfo
    {
        #region Private fields

        protected string _pspid = String.Empty;
        protected string _years = String.Empty;
        protected string _quarter = String.Empty;
        protected string _month = String.Empty;
        protected string _userid = String.Empty;
        protected string _sysdate = String.Empty;
        protected string _remark = String.Empty;
        protected string _m_stu = String.Empty;
        protected string _m_date = String.Empty;
        protected string _m_id = String.Empty;

        #endregion

        public purchaseplanInfo() { }

        #region Public Properties

        public string Pspid
        {
            get { return _pspid; }
            set { _pspid = value; }
        }

        public string Years
        {
            get { return _years; }
            set { _years = value; }
        }

        public string Quarter
        {
            get { return _quarter; }
            set { _quarter = value; }
        }

        public string Month
        {
            get { return _month; }
            set { _month = value; }
        }

        public string Userid
        {
            get { return _userid; }
            set { _userid = value; }
        }

        public string Sysdate
        {
            get { return _sysdate; }
            set { _sysdate = value; }
        }

        public string Remark
        {
            get { return _remark; }
            set { _remark = value; }
        }

        public string M_stu
        {
            get { return _m_stu; }
            set { _m_stu = value; }
        }

        public string M_date
        {
            get { return _m_date; }
            set { _m_date = value; }
        }

        public string M_id
        {
            get { return _m_id; }
            set { _m_id = value; }
        }

        #endregion

        #region Public SQL Script

        public string SQL_Insert()
        {
            return "insert into purchaseplan(Pspid,Years,Quarter,Month,Userid,Sysdate,Remark,M_stu,M_date,M_id) values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}')";
        }

        #endregion

    }

    #endregion
}

